LOAD DATA 
TRUNCATE INTO TABLE cafou_cardm_sec_tb 
FIELDS TERMINATED BY ';' 
TRAILING NULLCOLS 
(
 ISU_01		"TO_NUMBER(TRIM(BOTH FROM :ISU_01))"			--id_emetteur
,SEC_01		"TO_NUMBER(TRIM(BOTH FROM :SEC_01))"			--carrefour
,SEC_05		"TRIM(BOTH FROM SUBSTR(:SEC_05,1,64))"			--cusip
,SEC_07		"TRIM(BOTH FROM SUBSTR(:SEC_07,1,64))"			--sedol
,SEC_11		"TRIM(BOTH FROM SUBSTR(:SEC_11,1,10))"			--activite_caisse
,SEC_19		"TRIM(BOTH FROM SUBSTR(:SEC_19,1,10))"			--etat
,SEC_21		"TRIM(BOTH FROM SUBSTR(:SEC_21,1,48))"			--nom
,SEC_24		"TRIM(BOTH FROM SUBSTR(:SEC_24,1,64))"			--rics
,VAR_73		"TRIM(BOTH FROM SUBSTR(:VAR_73,1,64))"			--bbg_ticker
,SEC_51A	"TRIM(BOTH FROM SUBSTR(:SEC_51A,1,3))"			--devise
,VAR_72		"REPLACE(SUBSTR(TRIM(BOTH FROM :VAR_72),1,6),CHR(13),'')"	--type
,SEC_66         "TO_NUMBER(TRIM(BOTH FROM :SEC_66))"                    -- Conversion Ratio
,SEC_68         "TO_NUMBER(TRIM(BOTH FROM :SEC_68))"                    -- Underlying Security Alias 
,SEC_22       "SUBSTR(TRIM(BOTH FROM :SEC_22),1,50)"                    --se_com0
,SEC_M6       "SUBSTR(TRIM(BOTH FROM :SEC_M6),1,17)"                    --se_label
,SEC_27       "SUBSTR(TRIM(BOTH FROM :SEC_27),1,50)"                    --Bloomberg security type1
,SEC_28       "SUBSTR(TRIM(BOTH FROM :SEC_28),1,50)"                    --Bloomberg security type2
,SEC_82       "SUBSTR(TRIM(BOTH FROM :SEC_82),1,8)"                     --ETF Underlying index ticker
)
